UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yBN+PredN03xAWsK7BJmUHFgYacWLlEs4sjo5NVpdVg='
WHERE
key_id = 'b0eee301d134bd0e0a15e8d698f50377fc3e0d9828d1c2d7b6de690437a63020'
AND (
token = 'yBN+PredN03xAWsK7BJmUHFgYacWLlEs4sjo5NVpdVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)