UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wljJ2dWNwKnViUokwVVyhYskh5bS+9gol5vXVJxTcVI='
WHERE
key_id = 'a8d7b3ad8c187501b9891d4e538e4a058e15a06c670a127a2829e531caf05e72'
AND (
token = 'wljJ2dWNwKnViUokwVVyhYskh5bS+9gol5vXVJxTcVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)