UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnAeeojICkDKq7USg5ZWEFThP1QNm02bwmt8Y6UUCAI='
WHERE
key_id = '557e5d5556ced3d43f13e4fc596a838d6435f575a2bb09edb6f8dea9ac2173e4'
AND (
token = 'fnAeeojICkDKq7USg5ZWEFThP1QNm02bwmt8Y6UUCAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)