UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfJa0RqOwrM3HqLMic70bYh+9X9tYNBcXfJjKwjwvCI='
WHERE
key_id = 'd8f107dc41affad322e3621445a3e9dc64003d25a3d843c227154babbeb8bd84'
AND (
token = 'TfJa0RqOwrM3HqLMic70bYh+9X9tYNBcXfJjKwjwvCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)