UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGqgyea/Gh1AKEDp7FUJReyciNyZ/snlMat2bBmmMJE='
WHERE
key_id = 'b47c7a77546c546207ddd8fbd1d6c186e363a88837303b88ff143c1589c3bc39'
AND (
token = 'NGqgyea/Gh1AKEDp7FUJReyciNyZ/snlMat2bBmmMJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)