UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rpO6t3Hce8Wkqsa5R+y1lfz0rfcSvRdawK6QW68R54='
WHERE
key_id = 'ae8e8206574b640b91fab52db8c83cd28ef1b3e345518de9b2796ea4aec22a7d'
AND (
token = '8rpO6t3Hce8Wkqsa5R+y1lfz0rfcSvRdawK6QW68R54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)