UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPus6KUkP9AuLKrdkLdashkGzH9xbJ3//DRm7UxmEWo='
WHERE
key_id = 'fdd5a98ab3b66f87ba3e3f09a949ee0bcd6ec70779dabb7f95bfacca2df11e58'
AND (
token = 'BPus6KUkP9AuLKrdkLdashkGzH9xbJ3//DRm7UxmEWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)