UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NIGJ/v2s8B8UxWLjz0k7jXaFkPBF8fEp78dnlU3HWwQ='
WHERE
key_id = '783f2a8c2d1b018bc8b56bcebf1bb61c7e6954a6ef2ebfe7e814aeaa50d42f8a'
AND (
token = 'NIGJ/v2s8B8UxWLjz0k7jXaFkPBF8fEp78dnlU3HWwQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)