UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8ZUbnBCx1/8lOpKj1+6oYqYpfgP/2gJzNxwSuge+28='
WHERE
key_id = 'a48b59e675108b5b85714832d88f2c76ba28a8ca20ab13c58b1a1cda68500a07'
AND (
token = 'e8ZUbnBCx1/8lOpKj1+6oYqYpfgP/2gJzNxwSuge+28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)