UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GuanEc9KZ+5I8YIudZ2F1YbtUpR3srttSgRSINPJRcI='
WHERE
key_id = '3caed658d4e01779fc711e03e7fca1dfeb479ae79963901bb94560f1e85df2e3'
AND (
token = 'GuanEc9KZ+5I8YIudZ2F1YbtUpR3srttSgRSINPJRcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)