UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcfSCh5Nr6CBu7V85KnEdmtYobckvOs6Ce21NLtcRuQ='
WHERE
key_id = '5caf300f10fd3e11a56ba35417e773f160646c49f2154a791aab239cd87f042f'
AND (
token = 'NcfSCh5Nr6CBu7V85KnEdmtYobckvOs6Ce21NLtcRuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)