UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aR9vzE7pMkKRapCJlXZDJ1/E1vOyfYm9CX5qM0lQlmI='
WHERE
key_id = '8175163ab0f9abd04612867019486faaa206d47e423b23c505d94c2844c62691'
AND (
token = 'aR9vzE7pMkKRapCJlXZDJ1/E1vOyfYm9CX5qM0lQlmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)