UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHBUQqHFDi39mAFg2y0ieHObQKz9ZcVOCyYdWYNeWCw='
WHERE
key_id = 'cbfc9364d1695f7a6826b0cf2255d1d046654190022713e107388a8a4ad39150'
AND (
token = 'fHBUQqHFDi39mAFg2y0ieHObQKz9ZcVOCyYdWYNeWCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)