UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIGCQTLF8tMOQDjBc2W65wCaYSFwZL+VnKyVelt/b20='
WHERE
key_id = '499619fc8b0bb6699db75fca49d9e977addce8271a4f2a52e8fc6c9bb66d15df'
AND (
token = 'HIGCQTLF8tMOQDjBc2W65wCaYSFwZL+VnKyVelt/b20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)