UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNqy26dMY0ObUOhHikee17decNga70fMqMOKNjuxRZs='
WHERE
key_id = 'ea0914b0dc3330fe28b269a438b46e9dad320f99d6371f109ffa7bb1fc7c0083'
AND (
token = 'SNqy26dMY0ObUOhHikee17decNga70fMqMOKNjuxRZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)