UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6L1SViJygA3qxdz4iP8UAa0r91H0dP3VUMW+fKb1xo='
WHERE
key_id = '4392bda427d58e04867ba3bd5558b559649610fa1b65a6dd3174281ae4286a9e'
AND (
token = 'Z6L1SViJygA3qxdz4iP8UAa0r91H0dP3VUMW+fKb1xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)