UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07Wf4CHuhLBAScfIaZPHv0yrHXNm+42q2ZBGA7nIbsg='
WHERE
key_id = '13d8145e4d9fa5ccc327c65cd3397beefe965656a6ddb8673d99f9b112f31636'
AND (
token = '07Wf4CHuhLBAScfIaZPHv0yrHXNm+42q2ZBGA7nIbsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)