UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6VaUTy8J5ZQpIwaiDwirYifQnPfaBuIRGdllXMvd94='
WHERE
key_id = 'be5f7547a1da21ef81a63b38359b7a4ddaccc04ca8e822e47897e07f70befd50'
AND (
token = 'g6VaUTy8J5ZQpIwaiDwirYifQnPfaBuIRGdllXMvd94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)