UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OXvRoghi0tHv31kKdQJMZ5boAbXlgZFD+9XS01bM1YE='
WHERE
key_id = '816ce97247c58c8965f6d6a213ff043d9e351be2b71f8474500a5908d84e0664'
AND (
token = 'OXvRoghi0tHv31kKdQJMZ5boAbXlgZFD+9XS01bM1YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)