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