UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8rX+qCHhkZPPIfAqU0VCEVF5IyC6bSyVhYrbh3caQI='
WHERE
key_id = '3a0f4f20beced561aafe7f442470d15e4383ab15d40008dd54fcd9d18bb3a044'
AND (
token = 'p8rX+qCHhkZPPIfAqU0VCEVF5IyC6bSyVhYrbh3caQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)