UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROIwFnteBGL9NItUa+I1F4jqScGTPhe9ANym0cmuOKM='
WHERE
key_id = 'a01767d1f506ac27d72e27606e191a8fc4bea9e5219946154ae69e253b28abc5'
AND (
token = 'ROIwFnteBGL9NItUa+I1F4jqScGTPhe9ANym0cmuOKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)