UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpSWrhr/Ijf9651DJnobUb7IdL90o7YPYogrmYGScf0='
WHERE
key_id = 'd48f32700ca9377167a4c00a4275a2911ae78b1ace2fc05bed85b3f0289b96c3'
AND (
token = 'vpSWrhr/Ijf9651DJnobUb7IdL90o7YPYogrmYGScf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)