UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EeYVIjcSGn7El+IUF7Z5M8nUD24O9UeYxvxf/85ykLo='
WHERE
key_id = 'e87cb3a4cc906f636fbab3150874c0f56dbc00235055addc4f38f37a5fcc63b5'
AND (
token = 'EeYVIjcSGn7El+IUF7Z5M8nUD24O9UeYxvxf/85ykLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)