UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krXRLhbcQJLfx89OIMd1vaVjNNzaMZm/s+vgjvZ6tug='
WHERE
key_id = 'd7334ae9c8e777b63253442e886628c07cc93730e20286c354d493ac6ba7b278'
AND (
token = 'krXRLhbcQJLfx89OIMd1vaVjNNzaMZm/s+vgjvZ6tug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)