UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0e5ZDS9Qa/ZI8POK6uwkINntIDwNGNIW6bElkNoVPxw='
WHERE
key_id = 'da523a2bc580bb0152ed59a3c9854cdce5c90681389d76af5671a9d5aa6c2d78'
AND (
token = '0e5ZDS9Qa/ZI8POK6uwkINntIDwNGNIW6bElkNoVPxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)