UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xStImsWsRdcQzT5LGh0FCa68VKNNaZSsqoVg3b5+4lg='
WHERE
key_id = 'bb1c5f1d3771c1fb45b87d968ef607e0dbea56aaa3ed5f3cba6d59ade31f8d74'
AND (
token = 'xStImsWsRdcQzT5LGh0FCa68VKNNaZSsqoVg3b5+4lg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)