UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKCNcMZcS9jbM4zd5/fksoDp8xW+ImUlZYIRh5NgGIo='
WHERE
key_id = 'd727b7c3b207fb1e1de650b822ee92fdd9afa964b163b48ff73d5c483afb665a'
AND (
token = 'CKCNcMZcS9jbM4zd5/fksoDp8xW+ImUlZYIRh5NgGIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)