UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fGa/zVmKhfjUc+3i2zxReo38SOjVgsD7HCmZ7jl2GXo='
WHERE
key_id = 'e23650cc1cd10f9c325cb5ab9263c51bcf52f23f96c252c272b59e48f1a148e8'
AND (
token = 'fGa/zVmKhfjUc+3i2zxReo38SOjVgsD7HCmZ7jl2GXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)