UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GJvyIYKx3z7RLpUgcGER0fzzXRyz/1bOIfEfHyESajU='
WHERE
key_id = '9a8189b4eb1cc6efbe6e2271e5777c73c4c9fd694d0098ff4c7592da5088c001'
AND (
token = 'GJvyIYKx3z7RLpUgcGER0fzzXRyz/1bOIfEfHyESajU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)