UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5z2YDOam2qo9+szMsgvojFfpmNTYZYZmb3l9jTxxS4='
WHERE
key_id = '84bec384d959a072734e2da0391b691905b3e52e67ef123a7a8e3ad100c0245e'
AND (
token = 'S5z2YDOam2qo9+szMsgvojFfpmNTYZYZmb3l9jTxxS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)