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