UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8+/oHTHFlK1PUBiahxTKCV59Rudtkp9cdP9rKR9QtBs='
WHERE
key_id = '27c289db173b4e5919559d3c2e7ffe7abaa20dedf123b28cb85d9339d4835bdc'
AND (
token = '8+/oHTHFlK1PUBiahxTKCV59Rudtkp9cdP9rKR9QtBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)