UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHtTD9hMxM/fjCGjU6QI5QbOW2qZjsgtrPpX6OOndB8='
WHERE
key_id = 'c498b9694af8fd3e00e06112b8d2c3f1834111d571bb483de32a049882e581e1'
AND (
token = 'hHtTD9hMxM/fjCGjU6QI5QbOW2qZjsgtrPpX6OOndB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)