UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4T2YOgJ+J8GKpt7uqpF76j0NchPgLf78q9/Xy3yMUDg='
WHERE
key_id = '977f9de7913325206a208e2890b6a2272d4b37554d5c977e4213243b45e2eb9f'
AND (
token = '4T2YOgJ+J8GKpt7uqpF76j0NchPgLf78q9/Xy3yMUDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)