UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Kjb083CYVlb6m5aXzsFTiZQnro1yKuHJLGjaUD6s8M='
WHERE
key_id = '8562df99ad69fac8b002157d37153aaa3cc4986c4456ffc2bb719ba764e2d89e'
AND (
token = '/Kjb083CYVlb6m5aXzsFTiZQnro1yKuHJLGjaUD6s8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)